Home

Charts and Visualizing Data

59 Conversations

Latest Activity

Custom List Message Item

Hi

How can I make a graph showing total attendance (grand total) data from a pivot table, so I can show how total attendance changes over time?

Thanks

Untitled picture.png

Read More
21 Views
1 Reply

Dave,

 

I can only guess: Remove the Date field from the columns area.

 

Hi,

can not change option (like on the image). I do not understand, why is it unclickable. Can you help me please?

36 Views
0 Reply

I am using Excel 2016 with Windows 7.  I am happy to see that there is now a boxplot chart feature, but there seems to be a lot of bugs when I try to use it.  I am not sure if there are some issues with my operating system or the development of the featur

... Read More
32 Views
0 Reply

For filled map we naturally can't show multiple series at once, here is one of the ways how we may shift from one to another.

 

I took first figures I found, internet usage in EU countries, and limit them by three countries:

MapCharts01.JPG

Next we 'unpivot' these data copy

... Read More
62 Views
0 Reply

Hi, 

 

I have made a planbord in Excel. 

 

Rows for the differt articles that need to be produced and colums per day to show the department that is working on it.

 

Now I can make an overview per day, but i also want to make it for a week. 

I just haven't figure

... Read More
33 Views
0 Reply

Hello,

 

I'm trying to use 3D Maps in Excel 2016 with a Microsoft-supplied sample file (Chicago Narcotics Sample File). When I click Insert -> 3D Map, I get the option to insert Tours, as expected. However, when I click on a tour and the separate 3D Map win

... Read More
405 Views
3 Replies

Any update on this? Did you ever find a solution? I am having the same issue.

If there are no blank rows or columns in your data, and you don't want to exclude any part of them, you don't need to manually select the data, just select one cell of them, or any adjacent cell to your data, then insert a specific chart, or press Alt+F1

... Read More
51 Views
0 Reply

Hi,

Does anyone know how to achieve this kind of graph? (assuming the x's are numbers of course)

Thanks,

MikeScreenshot.png

Read More
27 Views
0 Reply

Hi,

 

I have a column, C, of the form: C6=IF(OR(A6="",B6=""),"",A6-B6) where A and B are columns with mostly numerical values but occasionally blanks. The formula, rather than a simple C=A-B, ensures C is also blank if either of A or B are blank. So my colu

... Read More
71 Views
5 Replies

Hi Richard,

 

Right click on your chart, Select Data in the menu, Hidden and Empty Cells button at bottom left, select Gaps

Gaps.JPG

 

Read More

Hi,

 

I have some graphs in Excel which use data from a table in a separate tab, my history tab. Every day I update this history tab by copying a bunch a data through a macro button to this history tab. So basically the list with data grows by one line ever

... Read More
60 Views
3 Replies
Format your table as table (Home tab, format as table) making sure all current data is within the table. Then update your chart so it points to all rows in your table. Ne... Read More
Best Response confirmed by Frank Hille (New Contributor)

Ciao,

 

I have an easy question, I hope you can help me.

 

I have a table with in column A a list of project codes(code ex is E-APT00200_15). I want to filter column A for a group of project codes. I could do it one by one, selecting everytime the button "add

... Read More
193 Views
6 Replies

Hi Michele,

 

Not sure i understand everything, but

1) Let assume you have a table with codes like this

 

Table1.JPG

and you filtered it somehow, let say only Code1 and Code3 are selecte

... Read More

Is there any way to enlarge the little squares on the left of the series legend on a column chart?  My old eyes have trouble seeing the colors of such small boxes.

Thanks,

Bob

38 Views
1 Reply

Hi Bob,

 

They are in the same size as font size of the legend text, you may increase/decrease them only together. The workaround could be creating of dummy legend with box

... Read More

data.JPGHi, I need help to stack the data of a graphic in a single column, but I just can in three

Read More
53 Views
2 Replies

Hi Damaso,

 

With PivotTable that's if switch rows/columns

 

StackedColumn.JPG

Read More

I have a data exported into an XML file which I map into excel. Then I convert this data into a pivot table to get the total count necessary columns. 

 

In the attached excel file, I'd like to get a count of "Trades" column only if the corresponding cell in

... Read More
110 Views
1 Reply

Anwesh,

 

add a column "Empty?" to your table with this formula:

=COUNTA(C2.E2)=0

Drag the fileld into the report filter and filter for FALSE.

 

Read More
Best Response confirmed by Anwesh Gangula (Occasional Contributor)

I'm creating a series of slicers on a sheet to easily show the different column values for one record.

 

One sheet has a pivot table so all the data is linked, however the rest of the data are on different sheets and not in pivot tables.

 

Though the slicers

... Read More
90 Views
2 Replies
Check if all columns have headers, there could be a way to do this, could you share each table headers and what you want to filter with each slicer?

I've created a program for a client where there are a number of charts in Excel - and have them linked to powerpoint files (on both Windows and Mac).  The simple example is a basic clustered column chart (say there are 4 columns of data: Year 1, Year 2, Y

... Read More
109 Views
0 Reply

Hello,

 

I would like to create a map in Excel. I have Excel 2016, and according to the tutorial video online, I should be able to create a map of the US that shows differenct values for different areas. The button should be under "Insert" and in the Charts

... Read More
247 Views
5 Replies
Hi,
Could you please confirm that excel 2016 (I AM NOT TALKING ABOUT OFFICE 365) does NOT come with map charts, it ONLY comes with 3D maps ???

AND if that is the case, coul... Read More

Hi Klara,

 

Maps chart is available for Office 365 subscribers only, is that your case?

Hi all, I have 10 groups that each one has 4 levels. Just wondering how show each level of the groups with different color, e.g., first level in all groups be recognized with yellow, second one with green…

 

 

59 Views
0 Reply

I hope someone can help or guide me in the right direction!

Let's say I have two values in Sheet1 (True & False) and these values can increase or decrease.

How can I set up a dynamic chart or may be a line graph (Corresponding to Value True and False) on a

... Read More
77 Views
0 Reply

Hi, I have a problem with my heatmap. I would like to add ann option to a dashboard that would show me for example just clients with 4 or more red/green fields. I work on excel 2010. 

Example of how my heatmap look is attached. 

59 Views
1 Reply

Hi Bartosz,

You have some conditions for your red/green rules. Add one more heleper column to your range and COUNTIF in it from B to I where such condition(s) match. After

... Read More

Can anyone help me with conditional formatting on a different level in a pivot table?

 I have 3 levels - Product category > Sub Category > Product. I want to apply conditional formatting to only relative to the products cells. In Windows, I have seen that

... Read More
124 Views
0 Reply

I would like to print my excel charts to my Canon Por-100 with the highewst possible resolution. How can I increase the resolution of my Excel charts. Microsoft gives instructions entitled: "How to change the export resolution of a PowerPoint slide". My q

... Read More
69 Views
1 Reply

Hello,

Excel does not have a setting to change the chart resolution. AFAIK, the printer driver will determine how the chart is printed. This has nothing to do with export

... Read More

I can see the 3-D map &  can use the the Flat to 2-D, but I don't see the Map Chart in Office 365  ProPlus.mapchart.png

 

How can I add it in?

Read More
57 Views
0 Reply

Hi all,

 

I have a rather huge excel (about 40M file size) with a lot of rather complex calculations (over 500.000).

Might be this is the reason ... but I can't insert a picture or a chart anymore. The respective icons are grey, copy&paste a picture leads to

... Read More
171 Views
5 Replies

Greyed out icons usually refer to some kind of protection (workbook or worksheet).

Or it is a shared workbook where some features are not possible or allowed.

 

Read More

How do I organize my list alphabetically  on XL spreadsheet so it starts with A and ends with Z names

68 Views
1 Reply

Hi Nora,

 

Depends on what do you mean under the list, Data->Sort in Ribbon menu could work