Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart Set Up
I am trying to create a chart that shows goal, projection and actual dollar
columns by month for an entire calndar year. I can get the columns on the chart but I can't figure out how to arrange my data to show each month below. Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart Set Up
You mean you can't get the chart to use the month data as categories on the
X axis? With an existing chart, go to Chart menu Source Data, and on the series tab, click in the Category Labels entry box, and with the mouse select the range. For a new chart, put the labels column to the left of the other data columns, put a column header on the Y value columns, and leave the column header on the labels column blank. Select the whole range and run the chart wizard. Excel sees the blank cell and knows the first row and column are different, i.e., category labels and series names. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "BMC Ops" <BMC wrote in message ... I am trying to create a chart that shows goal, projection and actual dollar columns by month for an entire calndar year. I can get the columns on the chart but I can't figure out how to arrange my data to show each month below. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a chart(? pie chart) that shows customers,dates and machi | Charts and Charting in Excel | |||
Excel 2003: How to nudge a chart element or shape on a chart? | Charts and Charting in Excel | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel |